SELECT events.*, eventToShluchaAndDate.* FROM events
LEFT JOIN eventToShluchaAndDate ON events.eventID = eventToShluchaAndDate.eventToShluchEventID
WHERE events.mercazAllId=45 AND eventID=24043
AND eventToShluchFromTime != '00:00:00' AND eventToShluchToTime != '00:00:00'